Changing the ODBC data source accessed by a report

1. Choose Set Location from the Database menu.

   The Set Location dialog box appears with a list of table aliases for the tables displayed in the report and will display the locations and logon information for the table you select below the list of tables.

   

2. Highlight the first table in this list box.
3. Click Set Location.
4. Choose the original ODBC data source to log on if you are not logged on already. You must log on to the old data source before you can modify a report to use a new data source. Since you must be logged on to the old data source, the old data source must be available on the local machine.
   • If the machine is no longer connected to the old server, you can install an ODBC data source with the name of the old data source and have it point to the new database server. Log on to this data source as you would log on to the "old" data source.
   • If you are using the same data source name to connect to a new server, you must configure that data source in the ODBC Data Source Administrator (found in the Control Panel), and make it point to the new server.

     After you log on to the old data source, double-click it so the list of tables appears in the Data Explorer dialog box.

5. Choose the new data source within the Data Explorer dialog box to log on.

   You should now be logged on to both the old and the new data sources.

6. Double-click the new data source to display its tables, then select the appropriate table from this list. The table you choose should correspond to the first table you selected in the Set Location dialog box.
7. After clicking Set the program prompts you to change the location of all tables in the report to the location you specified for the first table.

   

8. Click Yes to set the location of all tables in the report to the same database.
9. Close the Set Location dialog box, and choose Verify Database from the Database menu to refresh the table definitions in the report.
10. Log off the old data source.
11. Save the report.